package com.hifar.test.exportdetail8357.controller;

import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.hifar.fw.utils.lang.StringUtils;
import com.hifar.plat.baseModal.service.IBaseOssFilesService;
import com.hifar.plat.officUtil.ExcelTemplateUtil;
import com.hifar.test.exportdetail8357.pojo.SysSyncExportDetail8357;
import com.hifar.test.exportdetail8357.service.ISysSyncExportDetail8357Service;
import com.hifar.sys.BusiResponse;
import com.hifar.sys.PageResult;
import com.hifar.sys.RequestConver;
import com.hifar.sys.SystemLoginUser;
import com.hifar.sys.SystemUtil;

import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;

/**
 * <p>
 * 双网同步-导出-明细表 前端控制器 default
 * </p>
 *
 * @author wangkepeng
 * @since 2024-11-13 17:11:57
 */
@RestController
@RequestMapping("/api/busi/test/sysSyncExportDetail8357Controller")
@Api(tags = "双网同步-导出-明细表功能")
public class SysSyncExportDetail8357Controller {

    @Autowired
    private ISysSyncExportDetail8357Service sysSyncExportDetail8357Service;

    @Autowired
    private IBaseOssFilesService baseOssFilesService;

    @PostMapping(value = "/list")
    @ApiOperation(value = "双网同步-导出-明细表功能:分页查询列表")
    public BusiResponse list(HttpServletRequest request) {
        Map<String, Object> pageInfo = RequestConver.getPageInfo(request);
        QueryWrapper<SysSyncExportDetail8357> queryWrapper = RequestConver.getPostParam(pageInfo);
        queryWrapper.orderByDesc("create_time");
        queryWrapper.in("secret_level", SystemLoginUser.dataSecretSet);
        String mainId = StringUtils.trimNull(pageInfo.get("mainId"));
        queryWrapper.eq("main_id", mainId);

        if (queryWrapper != null && pageInfo.size() > 0) {
            Page<SysSyncExportDetail8357> page = new Page<>((Integer) pageInfo.get("pageNo"), (Integer) pageInfo.get("pageSize"));
            Page<SysSyncExportDetail8357> page1 = sysSyncExportDetail8357Service.page(page, queryWrapper);
            page1.getRecords().forEach(item -> {
            });
            /*计算分页信息返回给前端*/
            PageResult pageResult = SystemUtil.parsePage(page, page1);
            return BusiResponse.OK(pageResult);
        } else {
            return BusiResponse.error("参数不正确！");
        }
    }

    @PostMapping(value = "/listAll")
    @ApiOperation(value = "双网同步-导出-明细表功能:查询列表(不带分页)")
    public BusiResponse listAll(HttpServletRequest request) {
        QueryWrapper<SysSyncExportDetail8357> queryWrapper = new QueryWrapper<>();
        queryWrapper.ne("del_flag", "1");
        queryWrapper.orderByDesc("create_time");
        queryWrapper.in("secret_level", SystemLoginUser.dataSecretSet);
        List<SysSyncExportDetail8357> list = sysSyncExportDetail8357Service.list(queryWrapper);
        list.forEach(item -> {
        });
        if (list != null && list.size() > 0) {
            return BusiResponse.OK(list);
        } else {
            return BusiResponse.ok("没有查询到数据！");
        }
    }

    @PostMapping(value = "/add")
    @ApiOperation(value = "双网同步-导出-明细表功能:新增")
    public BusiResponse add(@RequestBody SysSyncExportDetail8357 sysSyncExportDetail) {
        sysSyncExportDetail8357Service.save(sysSyncExportDetail);
        return BusiResponse.ok("添加成功");
    }


    @PostMapping(value = "/edit")
    @ApiOperation(value = "双网同步-导出-明细表功能:编辑")
    public BusiResponse edit(@RequestBody SysSyncExportDetail8357 sysSyncExportDetail) {
        sysSyncExportDetail8357Service.updateById(sysSyncExportDetail);
        return BusiResponse.ok("编辑成功！");
    }


    @GetMapping("/queryById")
    @ApiOperation(value = "双网同步-导出-明细表功能:根据id查询数据")
    public BusiResponse queryById(@RequestParam(value = "id") String id) {
        SysSyncExportDetail8357 byId = sysSyncExportDetail8357Service.getById(id);
        // 查询转换附件
        return BusiResponse.OK(byId);
    }


    @PostMapping("/delete")
    @ApiOperation(value = "双网同步-导出-明细表功能:逻辑删除")
    public BusiResponse delete(@RequestBody String id) {
        JSONObject jsonObject = JSON.parseObject(id);
        UpdateWrapper<SysSyncExportDetail8357> delete = new UpdateWrapper<>();
        delete.in("id", jsonObject.getString("id").split(","));
        delete.set("del_flag", "1");
        sysSyncExportDetail8357Service.update(delete);
        return BusiResponse.ok("删除成功！");
    }

    @PostMapping("/exportExcel")
    @ApiOperation(value = "双网同步-导出-明细表功能:导出数据")
    public Object exportExcel(HttpServletRequest request) {
        Map<String, Object> pageInfo = RequestConver.getPageInfo(request);
        if (pageInfo == null) {
            return BusiResponse.error("参数有误！");
        }
        BusiResponse export = sysSyncExportDetail8357Service.exportExcel(pageInfo);
        if (export.getCode() == com.hifar.fw.utils.bean.BusiConst.CODE_SUCCESS) {
            String encode = null;
            try {
                encode = URLEncoder.encode("双网同步-导出-明细表.xlsx", "UTF-8");
            } catch (UnsupportedEncodingException e) {
                e.printStackTrace();
            }
            HttpHeaders headers = new HttpHeaders();
            headers.add("Content-Type", "application/vnd.ms-excel");
            headers.add("Access-Control-Expose-Headers", "Content-Disposition");
            headers.add("Content-Disposition", "filename=" + encode);
            return ResponseEntity.status(HttpStatus.OK).headers(headers).body((byte[]) export.getData());
        }
        return export;
    }

    @PostMapping("/importExcel")
    @ApiOperation(value = "双网同步-导出-明细表功能:导入excel数据")
    public BusiResponse importExcel(@RequestParam("file") MultipartFile file) throws Exception {
        if (file.isEmpty()) {
            return BusiResponse.error("文件为空！");
        } else {
            if (ExcelTemplateUtil.isExcelFile(file)) {
                return sysSyncExportDetail8357Service.importExcel(file);
            } else {
                return BusiResponse.error("请上传excel文件！");
            }
        }
    }


}